using System.Data;
using System.Data.OracleClient;
namespace WPFExcelReport
{

    public partial class VVVLIEF
    {
        public void SetUpNewRow(ref DataRow dwReturn)
        {

            switch (app.company)
            {
                case "YGR":
                case "TST":
                default:
                    #region=========
                    dwReturn["VVMANDANT"] = app.Mandant;
                    dwReturn["VVLIEFSCH"] = "00000000";
                    dwReturn["VVLO"] = "01";
                    dwReturn["VVPRODST1"] = "M";
                    dwReturn["VVPRODST2"] = " ";
                    dwReturn["VVPRODST3"] = " ";
                    dwReturn["VVPRODST4"] = " ";
                    dwReturn["VVPRODST5"] = " ";
                    dwReturn["VVPRODST6"] = " ";
                    dwReturn["VVPRODST7"] = " ";
                    dwReturn["VVPRODST8"] = " ";
                    dwReturn["VVPRODST9"] = " ";
                    dwReturn["VVLIEFSCHTYP"] = "V";
                    dwReturn["VVKZINLEXP"] = "I";
                    dwReturn["VVSTATUS"] = "KO";
                    dwReturn["VVVERSART"] = "W  ";
                    dwReturn["VVSPED"] = "   ";
                    dwReturn["VVVERSARTU"] = "   ";
                    dwReturn["VVSPEDU"] = "   ";
                    dwReturn["VVVERSARTV"] = "   ";
                    dwReturn["VVSPEDV"] = "   ";
                    dwReturn["VVEBDAT"] = "0";
                    dwReturn["VVKZEBBUCH"] = " ";
                    dwReturn["VVLAND"] = "   ";
                    dwReturn["VVPLZ"] = "            ";
                    dwReturn["VVORT"] = "                                        ";
                    dwReturn["VVBZ"] = "  ";
                    dwReturn["VVBZBEZ"] = "             ";
                    dwReturn["VVCOUNTY"] = "    ";
                    dwReturn["VVCITY"] = "    ";
                    dwReturn["VVAVISNR"] = "00000000";
                    dwReturn["VVFBR"] = "0000";
                    dwReturn["VVLIEFBED"] = "   ";
                    dwReturn["VVKZKOSTBER"] = "N";
                    dwReturn["VVLANDU"] = "CN ";
                    dwReturn["VVPLZU"] = "C           ";
                    dwReturn["VVORTU"] = "d                                       ";
                    dwReturn["VVBZU"] = "  ";
                    dwReturn["VVBZBEZU"] = "             ";
                    dwReturn["VVCOUNTYU"] = "    ";
                    dwReturn["VVCITYU"] = "    ";
                    dwReturn["VVLIEFSCHGRP"] = " ";
                    dwReturn["VVVERSDAT"] = "0";
                    dwReturn["VVLIEFDAT"] = "0";
                    dwReturn["VVFIXDAT"] = "0";
                    dwReturn["VVVERPART"] = "1  ";
                    dwReturn["VVGUETERNR"] = "    ";
                    dwReturn["VVKZEINZEL"] = "J";
                    dwReturn["VVEINZTARA"] = "0";
                    dwReturn["VVEINZBRUT"] = "0";
                    dwReturn["VVEINZNET"] = "0";
                    dwReturn["VVANZ"] = "1";
                    dwReturn["VVTARA"] = "0";
                    dwReturn["VVBRUTTO"] = "0";
                    dwReturn["VVNETTO"] = "0";
                    dwReturn["VVVOLUMEN"] = "0";
                    dwReturn["VVANZSTK"] = "0";
                    dwReturn["VVNETMTR"] = "0";
                    dwReturn["VVWERT"] = "0000000000";
                    dwReturn["VVLB1"] = "  ";
                    dwReturn["VVANZPAL1"] = "0";
                    dwReturn["VVANZAPAL1"] = "0";
                    dwReturn["VVANZRPAL1"] = "0";
                    dwReturn["VVLB2"] = "  ";
                    dwReturn["VVANZPAL2"] = "0";
                    dwReturn["VVANZAPAL2"] = "0";
                    dwReturn["VVANZRPAL2"] = "0";
                    dwReturn["VVLB3"] = "  ";
                    dwReturn["VVANZPAL3"] = "0";
                    dwReturn["VVANZAPAL3"] = "0";
                    dwReturn["VVANZRPAL3"] = "0";
                    dwReturn["VVLB4"] = "  ";
                    dwReturn["VVANZPAL4"] = "0";
                    dwReturn["VVANZAPAL4"] = "0";
                    dwReturn["VVANZRPAL4"] = "0";
                    dwReturn["VVLB5"] = "  ";
                    dwReturn["VVANZPAL5"] = "0";
                    dwReturn["VVANZAPAL5"] = "0";
                    dwReturn["VVANZRPAL5"] = "0";
                    dwReturn["VVLB6"] = "  ";
                    dwReturn["VVANZPAL6"] = "0";
                    dwReturn["VVANZAPAL6"] = "0";
                    dwReturn["VVANZRPAL6"] = "0";
                    dwReturn["VVKOLP"] = "        ";
                    dwReturn["VVVPLP"] = "        ";
                    dwReturn["VVTPSTA"] = " ";
                    dwReturn["VVTPMA1"] = "    ";
                    dwReturn["VVTPMAANZ1"] = "0";
                    dwReturn["VVTPMA2"] = "    ";
                    dwReturn["VVTPMAANZ2"] = "0";
                    dwReturn["VVGTBS"] = "0";
                    dwReturn["VVGTBK"] = "0";
                    dwReturn["VVKM1"] = "0";
                    dwReturn["VVGTBZ"] = "0";
                    dwReturn["VVKM2"] = "0";
                    dwReturn["VVTARIF1"] = "        ";
                    dwReturn["VVORTKL1"] = "  ";
                    dwReturn["VVFRPFL1"] = "0";
                    dwReturn["VVLAKL1"] = "0";
                    dwReturn["VVFRSATZ1"] = "0";
                    dwReturn["VVFRERRECH1"] = "0";
                    dwReturn["VVMARGEP1"] = "0";
                    dwReturn["VVMARGEA1"] = "0";
                    dwReturn["VVSUMME1"] = "0";
                    dwReturn["VVTARIF2"] = "        ";
                    dwReturn["VVORTKL2"] = "  ";
                    dwReturn["VVFRPFL2"] = "0";
                    dwReturn["VVLAKL2"] = "0";
                    dwReturn["VVFRSATZ2"] = "0";
                    dwReturn["VVFRERRECH2"] = "0";
                    dwReturn["VVMARGEP2"] = "0";
                    dwReturn["VVMARGEA2"] = "0";
                    dwReturn["VVSUMME2"] = "0";
                    dwReturn["VVTARIF3"] = "        ";
                    dwReturn["VVORTKL3"] = "  ";
                    dwReturn["VVFRPFL3"] = "0";
                    dwReturn["VVLAKL3"] = "0";
                    dwReturn["VVFRSATZ3"] = "0";
                    dwReturn["VVFRERRECH3"] = "0";
                    dwReturn["VVMARGEP3"] = "0";
                    dwReturn["VVMARGEA3"] = "0";
                    dwReturn["VVSUMME3"] = "0";
                    dwReturn["VVPRAEMIEV"] = "0";
                    dwReturn["VVPOLICE"] = "          ";
                    dwReturn["VVGDATBIS"] = "0";
                    dwReturn["VVWERTV"] = "0";
                    dwReturn["VVWAEHRSLV"] = "   ";
                    dwReturn["VVNEBENKO"] = "0";
                    dwReturn["VVWAEHRSLN"] = "   ";
                    dwReturn["VVNACHNA"] = "0";
                    dwReturn["VVFESTBETR"] = "0";
                    dwReturn["VVVERZOLLT"] = "N";
                    dwReturn["VVKZABRFR"] = "N";
                    dwReturn["VVZAHLART"] = "Z";
                    dwReturn["VVZAHLBED"] = "100";
                    dwReturn["VVKZLSPERR"] = "N";
                    dwReturn["VVANAME1"] = "                                        ";
                    dwReturn["VVANAME2"] = "                                        ";
                    dwReturn["VVASTRASSE"] = "                                        ";
                    dwReturn["VVASTRASSE2"] = "                                        ";
                    dwReturn["VVALAND"] = "   ";
                    dwReturn["VVAPLZ"] = "            ";
                    dwReturn["VVAORT"] = "                                        ";
                    dwReturn["VVABZ"] = "  ";
                    dwReturn["VVABZBEZ"] = "             ";
                    dwReturn["VVACOUNTY"] = "    ";
                    dwReturn["VVACITY"] = "    ";
                    dwReturn["VVKUNDNRV"] = "00000000";
                    dwReturn["VVADRSLV"] = "01      ";
                    dwReturn["VVKUNDNRE"] = "00000000";
                    dwReturn["VVEMPFKZ"] = " ";
                    dwReturn["VVADRSLL"] = "        ";
                    dwReturn["VVADRSLO"] = "        ";
                    dwReturn["VVKUNDNRVF"] = "        ";
                    dwReturn["VVADRSLKVF"] = "        ";
                    dwReturn["VVADRSLLVF"] = "    ";
                    dwReturn["VVKUNDNRR"] = "00000000";
                    dwReturn["VVADRSLKR"] = "        ";
                    dwReturn["VVADRSLLR"] = "    ";
                    dwReturn["VVKUNDNRF"] = "        ";
                    dwReturn["VVADRSLKF"] = "        ";
                    dwReturn["VVADRSLLF"] = "    ";
                    dwReturn["VVANTEILF"] = "0";
                    dwReturn["VVPI"] = "N";
                    dwReturn["VVET"] = "N";
                    dwReturn["VVLS"] = "J";
                    dwReturn["VVPA"] = "N";
                    dwReturn["VVLA"] = "N";
                    dwReturn["VVFR"] = "N";
                    dwReturn["VVAV"] = "N";
                    dwReturn["VVDECKBLATT"] = " ";
                    dwReturn["VVLIEFSCHPOS"] = "000";
                    dwReturn["VVLPACKNR"] = "1";
                    dwReturn["VVANZTLIEF"] = "1";
                    dwReturn["VVANZTLIEFR"] = "1";
                    dwReturn["VVANZTLIEFB"] = "0";
                    dwReturn["VVLIEFTERM"] = "0";
                    dwReturn["VVFRACHTBE"] = "0000000000";
                    dwReturn["VVVB"] = "   ";
                    dwReturn["VVKZKUNDV"] = "N";
                    dwReturn["VVZONE"] = "    ";
                    dwReturn["VVKGBIS"] = "0";
                    dwReturn["VVKDVKL"] = "   ";
                    dwReturn["VVADRSLLUR"] = "        ";
                    dwReturn["VVVALUTA"] = "0";
                    dwReturn["VVVALDAT"] = "0";
                    dwReturn["VVEKON"] = "        ";
                    dwReturn["VVVERSIBE"] = "0000000000";
                    dwReturn["VVVSTK"] = "999";
                    dwReturn["VVLSTKPA"] = "999";
                    dwReturn["VVPAUFKRS"] = "  ";
                    dwReturn["VVPAUFLFD"] = "000000";
                    dwReturn["VVPAUFPOS"] = "000";
                    dwReturn["VVVERPKOST"] = "0";
                    dwReturn["VVKOSTBGR"] = "0";
                    dwReturn["VVVERPKOSTE"] = "0";
                    dwReturn["VVLIEFNR"] = "        ";
                    dwReturn["VVRENR"] = "          ";
                    dwReturn["VVREPOS"] = "0000";
                    dwReturn["VVREDAT"] = "0";
                    dwReturn["VVFRNETTO"] = "0";
                    dwReturn["VVFRKSTA"] = "N";
                    dwReturn["VVZOLLPAP"] = "N";
                    dwReturn["VVPROGRP"] = "K  ";
                    dwReturn["VVUEBKZ"] = " ";
                    dwReturn["VVDROFT"] = "J";
                    dwReturn["VVKREDLIM"] = "0000000000";
                    dwReturn["VVSWING"] = "0000000000";
                    dwReturn["VVRAITING"] = "   ";
                    dwReturn["VVVERS"] = "  ";
                    dwReturn["VVKREDBIS"] = "0";
                    dwReturn["VVKREDVON"] = "0";
                    dwReturn["VVLUEBKZ"] = "N";
                    dwReturn["VVFRDAT"] = "0";
                    dwReturn["VVFRZEIT"] = "0";
                    dwReturn["VVFRBENID"] = "        ";
                    dwReturn["VVKUNDNRRE"] = "        ";
                    dwReturn["VVLIEFART"] = " ";
                    dwReturn["VVKTRANSDAT"] = "0";
                    dwReturn["VVKTRANSUHR"] = "0";
                    dwReturn["VVKTRANSBEN"] = "        ";
                    dwReturn["VVKTRANSSTA"] = " ";
                    dwReturn["VVSTRANSDATA"] = "0";
                    dwReturn["VVSTRANSUHRA"] = "0";
                    dwReturn["VVSTRANSERL"] = " ";
                    dwReturn["VVSTRANSDATE"] = "0";
                    dwReturn["VVSTRANSUHRE"] = "0";
                    dwReturn["VVETRANSDAT"] = "0";
                    dwReturn["VVETRANSUHR"] = "0";
                    dwReturn["VVETRANSBEN"] = "        ";
                    dwReturn["VVAKTKZ"] = " ";
                    dwReturn["VVPSTKKZ"] = " ";
                    dwReturn["VVANZVP"] = "0";
                    dwReturn["VVWAEHRSL"] = "   ";
                    dwReturn["VVHWAEHRSL"] = "   ";
                    dwReturn["VVHEUROKURS"] = "0";
                    dwReturn["VVHEUROKURSVK"] = " ";
                    dwReturn["VVFEUROKURS"] = "0";
                    dwReturn["VVFEUROKURSVK"] = " ";
                    dwReturn["VVLOHNKD"] = "00000000";
                    dwReturn["VVARCHKZ"] = " ";
                    dwReturn["VVARCHDAT"] = "00000000";
                    dwReturn["VVARCHBEL"] = "00000000";
                    dwReturn["VVSEQUNO"] = "000000000000000";
                    dwReturn["VVLFDPN"] = "0000";
                    dwReturn["VVARTGRP"] = "   ";
                    dwReturn["VVAETINEU"] = " ";
                    dwReturn["VVPTARIF"] = " ";
                    dwReturn["VVANSPRECH"] = "        ";
                    dwReturn["VVANSPZUS"] = "                          ";
                    dwReturn["VVTRANSSEQ"] = "00000000";
                    dwReturn["VVEDI"] = " ";
                    dwReturn["VVEDIDAT"] = "00000000";
                    dwReturn["VVQUITTAIO"] = " ";
                    dwReturn["VVGESMTR"] = "000000000";
                    dwReturn["VVLOAD"] = "0000";
                    dwReturn["VVLVOR"] = " ";
                    dwReturn["VVUSERFRA"] = "        ";
                    dwReturn["VVZEUGNIS"] = " ";
                    dwReturn["VVFILLER"] = "                                                   ";
                    dwReturn["VVAENDZL"] = "0";
                    dwReturn["VVAENDBEN"] = "        ";
                    dwReturn["VVAENDDAT"] = "0";
                    dwReturn["VVNEUBEN"] = "        ";
                    dwReturn["VVNEUDAT"] = "0";
                    #endregion
                    break;
                case "JLT":
                    #region=========
                    dwReturn["VVMANDANT"] = app.Mandant;
                    dwReturn["VVLIEFSCH"] = "00000000";
                    dwReturn["VVLO"] = "01";
                    dwReturn["VVPRODST1"] = "M";
                    dwReturn["VVPRODST2"] = " ";
                    dwReturn["VVPRODST3"] = " ";
                    dwReturn["VVPRODST4"] = " ";
                    dwReturn["VVPRODST5"] = " ";
                    dwReturn["VVPRODST6"] = " ";
                    dwReturn["VVPRODST7"] = " ";
                    dwReturn["VVPRODST8"] = " ";
                    dwReturn["VVPRODST9"] = " ";
                    dwReturn["VVLIEFSCHTYP"] = "V";
                    dwReturn["VVKZINLEXP"] = "I";
                    dwReturn["VVSTATUS"] = "KO";
                    dwReturn["VVVERSART"] = "W  ";
                    dwReturn["VVSPED"] = "   ";
                    dwReturn["VVVERSARTU"] = "   ";
                    dwReturn["VVSPEDU"] = "   ";
                    dwReturn["VVVERSARTV"] = "   ";
                    dwReturn["VVSPEDV"] = "   ";
                    dwReturn["VVEBDAT"] = "0";
                    dwReturn["VVKZEBBUCH"] = " ";
                    dwReturn["VVLAND"] = "   ";
                    dwReturn["VVPLZ"] = "            ";
                    dwReturn["VVORT"] = "                                        ";
                    dwReturn["VVBZ"] = "  ";
                    dwReturn["VVBZBEZ"] = "             ";
                    dwReturn["VVCOUNTY"] = "    ";
                    dwReturn["VVCITY"] = "    ";
                    dwReturn["VVAVISNR"] = "00000000";
                    dwReturn["VVFBR"] = "0000";
                    dwReturn["VVLIEFBED"] = "   ";
                    dwReturn["VVKZKOSTBER"] = "N";
                    dwReturn["VVLANDU"] = "CN ";
                    dwReturn["VVPLZU"] = "C           ";
                    dwReturn["VVORTU"] = "d                                       ";
                    dwReturn["VVBZU"] = "  ";
                    dwReturn["VVBZBEZU"] = "             ";
                    dwReturn["VVCOUNTYU"] = "    ";
                    dwReturn["VVCITYU"] = "    ";
                    dwReturn["VVLIEFSCHGRP"] = " ";
                    dwReturn["VVVERSDAT"] = "0";
                    dwReturn["VVLIEFDAT"] = "0";
                    dwReturn["VVFIXDAT"] = "0";
                    dwReturn["VVVERPART"] = "1  ";
                    dwReturn["VVGUETERNR"] = "    ";
                    dwReturn["VVKZEINZEL"] = "J";
                    dwReturn["VVEINZTARA"] = "0";
                    dwReturn["VVEINZBRUT"] = "0";
                    dwReturn["VVEINZNET"] = "0";
                    dwReturn["VVANZ"] = "1";
                    dwReturn["VVTARA"] = "0";
                    dwReturn["VVBRUTTO"] = "0";
                    dwReturn["VVNETTO"] = "0";
                    dwReturn["VVVOLUMEN"] = "0";
                    dwReturn["VVANZSTK"] = "0";
                    dwReturn["VVNETMTR"] = "0";
                    dwReturn["VVWERT"] = "0000000000";
                    dwReturn["VVLB1"] = "  ";
                    dwReturn["VVANZPAL1"] = "0";
                    dwReturn["VVANZAPAL1"] = "0";
                    dwReturn["VVANZRPAL1"] = "0";
                    dwReturn["VVLB2"] = "  ";
                    dwReturn["VVANZPAL2"] = "0";
                    dwReturn["VVANZAPAL2"] = "0";
                    dwReturn["VVANZRPAL2"] = "0";
                    dwReturn["VVLB3"] = "  ";
                    dwReturn["VVANZPAL3"] = "0";
                    dwReturn["VVANZAPAL3"] = "0";
                    dwReturn["VVANZRPAL3"] = "0";
                    dwReturn["VVLB4"] = "  ";
                    dwReturn["VVANZPAL4"] = "0";
                    dwReturn["VVANZAPAL4"] = "0";
                    dwReturn["VVANZRPAL4"] = "0";
                    dwReturn["VVLB5"] = "  ";
                    dwReturn["VVANZPAL5"] = "0";
                    dwReturn["VVANZAPAL5"] = "0";
                    dwReturn["VVANZRPAL5"] = "0";
                    dwReturn["VVLB6"] = "  ";
                    dwReturn["VVANZPAL6"] = "0";
                    dwReturn["VVANZAPAL6"] = "0";
                    dwReturn["VVANZRPAL6"] = "0";
                    dwReturn["VVKOLP"] = "        ";
                    dwReturn["VVVPLP"] = "        ";
                    dwReturn["VVTPSTA"] = " ";
                    dwReturn["VVTPMA1"] = "    ";
                    dwReturn["VVTPMAANZ1"] = "0";
                    dwReturn["VVTPMA2"] = "    ";
                    dwReturn["VVTPMAANZ2"] = "0";
                    dwReturn["VVGTBS"] = "0";
                    dwReturn["VVGTBK"] = "0";
                    dwReturn["VVKM1"] = "0";
                    dwReturn["VVGTBZ"] = "0";
                    dwReturn["VVKM2"] = "0";
                    dwReturn["VVTARIF1"] = "        ";
                    dwReturn["VVORTKL1"] = "  ";
                    dwReturn["VVFRPFL1"] = "0";
                    dwReturn["VVLAKL1"] = "0";
                    dwReturn["VVFRSATZ1"] = "0";
                    dwReturn["VVFRERRECH1"] = "0";
                    dwReturn["VVMARGEP1"] = "0";
                    dwReturn["VVMARGEA1"] = "0";
                    dwReturn["VVSUMME1"] = "0";
                    dwReturn["VVTARIF2"] = "        ";
                    dwReturn["VVORTKL2"] = "  ";
                    dwReturn["VVFRPFL2"] = "0";
                    dwReturn["VVLAKL2"] = "0";
                    dwReturn["VVFRSATZ2"] = "0";
                    dwReturn["VVFRERRECH2"] = "0";
                    dwReturn["VVMARGEP2"] = "0";
                    dwReturn["VVMARGEA2"] = "0";
                    dwReturn["VVSUMME2"] = "0";
                    dwReturn["VVTARIF3"] = "        ";
                    dwReturn["VVORTKL3"] = "  ";
                    dwReturn["VVFRPFL3"] = "0";
                    dwReturn["VVLAKL3"] = "0";
                    dwReturn["VVFRSATZ3"] = "0";
                    dwReturn["VVFRERRECH3"] = "0";
                    dwReturn["VVMARGEP3"] = "0";
                    dwReturn["VVMARGEA3"] = "0";
                    dwReturn["VVSUMME3"] = "0";
                    dwReturn["VVPRAEMIEV"] = "0";
                    dwReturn["VVPOLICE"] = "          ";
                    dwReturn["VVGDATBIS"] = "0";
                    dwReturn["VVWERTV"] = "0";
                    dwReturn["VVWAEHRSLV"] = "   ";
                    dwReturn["VVNEBENKO"] = "0";
                    dwReturn["VVWAEHRSLN"] = "   ";
                    dwReturn["VVNACHNA"] = "0";
                    dwReturn["VVFESTBETR"] = "0";
                    dwReturn["VVVERZOLLT"] = "N";
                    dwReturn["VVKZABRFR"] = "N";
                    dwReturn["VVZAHLART"] = "Z";
                    dwReturn["VVZAHLBED"] = "100";
                    dwReturn["VVKZLSPERR"] = "N";
                    dwReturn["VVANAME1"] = "                                        ";
                    dwReturn["VVANAME2"] = "                                        ";
                    dwReturn["VVASTRASSE"] = "                                        ";
                    dwReturn["VVASTRASSE2"] = "                                        ";
                    dwReturn["VVALAND"] = "   ";
                    dwReturn["VVAPLZ"] = "            ";
                    dwReturn["VVAORT"] = "                                        ";
                    dwReturn["VVABZ"] = "  ";
                    dwReturn["VVABZBEZ"] = "             ";
                    dwReturn["VVACOUNTY"] = "    ";
                    dwReturn["VVACITY"] = "    ";
                    dwReturn["VVKUNDNRV"] = "00000000";
                    dwReturn["VVADRSLV"] = "01      ";
                    dwReturn["VVKUNDNRE"] = "00000000";
                    dwReturn["VVEMPFKZ"] = " ";
                    dwReturn["VVADRSLL"] = "        ";
                    dwReturn["VVADRSLO"] = "        ";
                    dwReturn["VVKUNDNRVF"] = "        ";
                    dwReturn["VVADRSLKVF"] = "        ";
                    dwReturn["VVADRSLLVF"] = "    ";
                    dwReturn["VVKUNDNRR"] = "00000000";
                    dwReturn["VVADRSLKR"] = "        ";
                    dwReturn["VVADRSLLR"] = "    ";
                    dwReturn["VVKUNDNRF"] = "        ";
                    dwReturn["VVADRSLKF"] = "        ";
                    dwReturn["VVADRSLLF"] = "    ";
                    dwReturn["VVANTEILF"] = "0";
                    dwReturn["VVPI"] = "N";
                    dwReturn["VVET"] = "N";
                    dwReturn["VVLS"] = "J";
                    dwReturn["VVPA"] = "N";
                    dwReturn["VVLA"] = "N";
                    dwReturn["VVFR"] = "N";
                    dwReturn["VVAV"] = "N";
                    dwReturn["VVDECKBLATT"] = " ";
                    dwReturn["VVLIEFSCHPOS"] = "000";
                    dwReturn["VVLPACKNR"] = "1";
                    dwReturn["VVANZTLIEF"] = "1";
                    dwReturn["VVANZTLIEFR"] = "1";
                    dwReturn["VVANZTLIEFB"] = "0";
                    dwReturn["VVLIEFTERM"] = "0";
                    dwReturn["VVFRACHTBE"] = "0000000000";
                    dwReturn["VVVB"] = "   ";
                    dwReturn["VVKZKUNDV"] = "N";
                    dwReturn["VVZONE"] = "    ";
                    dwReturn["VVKGBIS"] = "0";
                    dwReturn["VVKDVKL"] = "   ";
                    dwReturn["VVADRSLLUR"] = "        ";
                    dwReturn["VVVALUTA"] = "0";
                    dwReturn["VVVALDAT"] = "0";
                    dwReturn["VVEKON"] = "        ";
                    dwReturn["VVVERSIBE"] = "0000000000";
                    dwReturn["VVVSTK"] = "999";
                    dwReturn["VVLSTKPA"] = "999";
                    dwReturn["VVPAUFKRS"] = "  ";
                    dwReturn["VVPAUFLFD"] = "000000";
                    dwReturn["VVPAUFPOS"] = "000";
                    dwReturn["VVVERPKOST"] = "0";
                    dwReturn["VVKOSTBGR"] = "0";
                    dwReturn["VVVERPKOSTE"] = "0";
                    dwReturn["VVLIEFNR"] = "        ";
                    dwReturn["VVRENR"] = "          ";
                    dwReturn["VVREPOS"] = "0000";
                    dwReturn["VVREDAT"] = "0";
                    dwReturn["VVFRNETTO"] = "0";
                    dwReturn["VVFRKSTA"] = "N";
                    dwReturn["VVZOLLPAP"] = "N";
                    dwReturn["VVPROGRP"] = "K  ";
                    dwReturn["VVUEBKZ"] = " ";
                    dwReturn["VVDROFT"] = "J";
                    dwReturn["VVKREDLIM"] = "0000000000";
                    dwReturn["VVSWING"] = "0000000000";
                    dwReturn["VVRAITING"] = "   ";
                    dwReturn["VVVERS"] = "  ";
                    dwReturn["VVKREDBIS"] = "0";
                    dwReturn["VVKREDVON"] = "0";
                    dwReturn["VVLUEBKZ"] = "N";
                    dwReturn["VVFRDAT"] = "0";
                    dwReturn["VVFRZEIT"] = "0";
                    dwReturn["VVFRBENID"] = "        ";
                    dwReturn["VVKUNDNRRE"] = "        ";
                    dwReturn["VVLIEFART"] = " ";
                    dwReturn["VVKTRANSDAT"] = "0";
                    dwReturn["VVKTRANSUHR"] = "0";
                    dwReturn["VVKTRANSBEN"] = "        ";
                    dwReturn["VVKTRANSSTA"] = " ";
                    dwReturn["VVSTRANSDATA"] = "0";
                    dwReturn["VVSTRANSUHRA"] = "0";
                    dwReturn["VVSTRANSERL"] = " ";
                    dwReturn["VVSTRANSDATE"] = "0";
                    dwReturn["VVSTRANSUHRE"] = "0";
                    dwReturn["VVETRANSDAT"] = "0";
                    dwReturn["VVETRANSUHR"] = "0";
                    dwReturn["VVETRANSBEN"] = "        ";
                    dwReturn["VVAKTKZ"] = " ";
                    dwReturn["VVPSTKKZ"] = " ";
                    dwReturn["VVANZVP"] = "0";
                    dwReturn["VVWAEHRSL"] = "   ";
                    dwReturn["VVHWAEHRSL"] = "   ";
                    dwReturn["VVHEUROKURS"] = "0";
                    dwReturn["VVHEUROKURSVK"] = " ";
                    dwReturn["VVFEUROKURS"] = "0";
                    dwReturn["VVFEUROKURSVK"] = " ";
                    dwReturn["VVLOHNKD"] = "00000000";
                    dwReturn["VVARCHKZ"] = " ";
                    dwReturn["VVARCHDAT"] = "00000000";
                    dwReturn["VVARCHBEL"] = "00000000";
                    dwReturn["VVSEQUNO"] = "000000000000000";
                    dwReturn["VVLFDPN"] = "0000";
                    dwReturn["VVARTGRP"] = "   ";
                    dwReturn["VVAETINEU"] = " ";
                    dwReturn["VVPTARIF"] = " ";
                    dwReturn["VVANSPRECH"] = "        ";
                    dwReturn["VVANSPZUS"] = "                          ";
                    dwReturn["VVTRANSSEQ"] = "00000000";
                    dwReturn["VVEDI"] = " ";
                    dwReturn["VVEDIDAT"] = "00000000";
                    dwReturn["VVQUITTAIO"] = " ";
                    dwReturn["VVGESMTR"] = "000000000";
                    dwReturn["VVLOAD"] = "0000";
                    dwReturn["VVLVOR"] = " ";
                    dwReturn["VVUSERFRA"] = "        ";
                    dwReturn["VVZEUGNIS"] = " ";
                    dwReturn["VVFILLER"] = "                                                   ";
                    dwReturn["VVAENDZL"] = "0";
                    dwReturn["VVAENDBEN"] = "        ";
                    dwReturn["VVAENDDAT"] = "0";
                    dwReturn["VVNEUBEN"] = "        ";
                    dwReturn["VVNEUDAT"] = "0";
                    #endregion
                    break;
            }
        }

        public void InsertVVLIEF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
          
            dwData["VVNEUBEN"] = app.User;
            dwData["VVNEUDAT"] = date;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                case "YCC":
                default:
                    or1.CommandText = "INSERT INTO VVLIEF ( VVMANDANT,VVLIEFSCH,VVLO,VVPRODST1,VVPRODST2,VVPRODST3,VVPRODST4,VVPRODST5,VVPRODST6,VVPRODST7,VVPRODST8,VVPRODST9,VVLIEFSCHTYP,VVKZINLEXP,VVSTATUS,VVVERSART,VVSPED,VVVERSARTU,VVSPEDU,VVVERSARTV,VVSPEDV,VVEBDAT,VVKZEBBUCH,VVLAND,VVPLZ,VVORT,VVBZ,VVBZBEZ,VVCOUNTY,VVCITY,VVAVISNR,VVFBR,VVLIEFBED,VVKZKOSTBER,VVLANDU,VVPLZU,VVORTU,VVBZU,VVBZBEZU,VVCOUNTYU,VVCITYU,VVLIEFSCHGRP,VVVERSDAT,VVLIEFDAT,VVFIXDAT,VVVERPART,VVGUETERNR,VVKZEINZEL,VVEINZTARA,VVEINZBRUT,VVEINZNET,VVANZ,VVTARA,VVBRUTTO,VVNETTO,VVVOLUMEN,VVANZSTK,VVNETMTR,VVWERT,VVLB1,VVANZPAL1,VVANZAPAL1,VVANZRPAL1,VVLB2,VVANZPAL2,VVANZAPAL2,VVANZRPAL2,VVLB3,VVANZPAL3,VVANZAPAL3,VVANZRPAL3,VVLB4,VVANZPAL4,VVANZAPAL4,VVANZRPAL4,VVLB5,VVANZPAL5,VVANZAPAL5,VVANZRPAL5,VVLB6,VVANZPAL6,VVANZAPAL6,VVANZRPAL6,VVKOLP,VVVPLP,VVTPSTA,VVTPMA1,VVTPMAANZ1,VVTPMA2,VVTPMAANZ2,VVGTBS,VVGTBK,VVKM1,VVGTBZ,VVKM2,VVTARIF1,VVORTKL1,VVFRPFL1,VVLAKL1,VVFRSATZ1,VVFRERRECH1,VVMARGEP1,VVMARGEA1,VVSUMME1,VVTARIF2,VVORTKL2,VVFRPFL2,VVLAKL2,VVFRSATZ2,VVFRERRECH2,VVMARGEP2,VVMARGEA2,VVSUMME2,VVTARIF3,VVORTKL3,VVFRPFL3,VVLAKL3,VVFRSATZ3,VVFRERRECH3,VVMARGEP3,VVMARGEA3,VVSUMME3,VVPRAEMIEV,VVPOLICE,VVGDATBIS,VVWERTV,VVWAEHRSLV,VVNEBENKO,VVWAEHRSLN,VVNACHNA,VVFESTBETR,VVVERZOLLT,VVKZABRFR,VVZAHLART,VVZAHLBED,VVKZLSPERR,VVANAME1,VVANAME2,VVASTRASSE,VVASTRASSE2,VVALAND,VVAPLZ,VVAORT,VVABZ,VVABZBEZ,VVACOUNTY,VVACITY,VVKUNDNRV,VVADRSLV,VVKUNDNRE,VVEMPFKZ,VVADRSLL,VVADRSLO,VVKUNDNRVF,VVADRSLKVF,VVADRSLLVF,VVKUNDNRR,VVADRSLKR,VVADRSLLR,VVKUNDNRF,VVADRSLKF,VVADRSLLF,VVANTEILF,VVPI,VVET,VVLS,VVPA,VVLA,VVFR,VVAV,VVDECKBLATT,VVLIEFSCHPOS,VVLPACKNR,VVANZTLIEF,VVANZTLIEFR,VVANZTLIEFB,VVLIEFTERM,VVFRACHTBE,VVVB,VVKZKUNDV,VVZONE,VVKGBIS,VVKDVKL,VVADRSLLUR,VVVALUTA,VVVALDAT,VVEKON,VVVERSIBE,VVVSTK,VVLSTKPA,VVPAUFKRS,VVPAUFLFD,VVPAUFPOS,VVVERPKOST,VVKOSTBGR,VVVERPKOSTE,VVLIEFNR,VVRENR,VVREPOS,VVREDAT,VVFRNETTO,VVFRKSTA,VVZOLLPAP,VVPROGRP,VVUEBKZ,VVDROFT,VVKREDLIM,VVSWING,VVRAITING,VVVERS,VVKREDBIS,VVKREDVON,VVLUEBKZ,VVFRDAT,VVFRZEIT,VVFRBENID,VVKUNDNRRE,VVLIEFART,VVKTRANSDAT,VVKTRANSUHR,VVKTRANSBEN,VVKTRANSSTA,VVSTRANSDATA,VVSTRANSUHRA,VVSTRANSERL,VVSTRANSDATE,VVSTRANSUHRE,VVETRANSDAT,VVETRANSUHR,VVETRANSBEN,VVAKTKZ,VVPSTKKZ,VVANZVP,VVWAEHRSL,VVHWAEHRSL,VVHEUROKURS,VVHEUROKURSVK,VVFEUROKURS,VVFEUROKURSVK,VVLOHNKD,VVARCHKZ,VVARCHDAT,VVARCHBEL,VVSEQUNO,VVLFDPN,VVARTGRP,VVAETINEU,VVPTARIF,VVANSPRECH,VVANSPZUS,VVTRANSSEQ,VVEDI,VVEDIDAT,VVQUITTAIO,VVGESMTR,VVLOAD,VVLVOR,VVUSERFRA,VVZEUGNIS,VVFILLER,VVAENDZL,VVAENDBEN,VVAENDDAT,VVNEUBEN,VVNEUDAT)"
                    + " VALUES (:VVMANDANT:,:VVLIEFSCH:,:VVLO:,:VVPRODST1:,:VVPRODST2:,:VVPRODST3:,:VVPRODST4:,:VVPRODST5:,:VVPRODST6:,:VVPRODST7:,:VVPRODST8:,:VVPRODST9:,:VVLIEFSCHTYP:,:VVKZINLEXP:,:VVSTATUS:,:VVVERSART:,:VVSPED:,:VVVERSARTU:,:VVSPEDU:,:VVVERSARTV:,:VVSPEDV:,:VVEBDAT:,:VVKZEBBUCH:,:VVLAND:,:VVPLZ:,:VVORT:,:VVBZ:,:VVBZBEZ:,:VVCOUNTY:,:VVCITY:,:VVAVISNR:,:VVFBR:,:VVLIEFBED:,:VVKZKOSTBER:,:VVLANDU:,:VVPLZU:,:VVORTU:,:VVBZU:,:VVBZBEZU:,:VVCOUNTYU:,:VVCITYU:,:VVLIEFSCHGRP:,:VVVERSDAT:,:VVLIEFDAT:,:VVFIXDAT:,:VVVERPART:,:VVGUETERNR:,:VVKZEINZEL:,:VVEINZTARA:,:VVEINZBRUT:,:VVEINZNET:,:VVANZ:,:VVTARA:,:VVBRUTTO:,:VVNETTO:,:VVVOLUMEN:,:VVANZSTK:,:VVNETMTR:,:VVWERT:,:VVLB1:,:VVANZPAL1:,:VVANZAPAL1:,:VVANZRPAL1:,:VVLB2:,:VVANZPAL2:,:VVANZAPAL2:,:VVANZRPAL2:,:VVLB3:,:VVANZPAL3:,:VVANZAPAL3:,:VVANZRPAL3:,:VVLB4:,:VVANZPAL4:,:VVANZAPAL4:,:VVANZRPAL4:,:VVLB5:,:VVANZPAL5:,:VVANZAPAL5:,:VVANZRPAL5:,:VVLB6:,:VVANZPAL6:,:VVANZAPAL6:,:VVANZRPAL6:,:VVKOLP:,:VVVPLP:,:VVTPSTA:,:VVTPMA1:,:VVTPMAANZ1:,:VVTPMA2:,:VVTPMAANZ2:,:VVGTBS:,:VVGTBK:,:VVKM1:,:VVGTBZ:,:VVKM2:,:VVTARIF1:,:VVORTKL1:,:VVFRPFL1:,:VVLAKL1:,:VVFRSATZ1:,:VVFRERRECH1:,:VVMARGEP1:,:VVMARGEA1:,:VVSUMME1:,:VVTARIF2:,:VVORTKL2:,:VVFRPFL2:,:VVLAKL2:,:VVFRSATZ2:,:VVFRERRECH2:,:VVMARGEP2:,:VVMARGEA2:,:VVSUMME2:,:VVTARIF3:,:VVORTKL3:,:VVFRPFL3:,:VVLAKL3:,:VVFRSATZ3:,:VVFRERRECH3:,:VVMARGEP3:,:VVMARGEA3:,:VVSUMME3:,:VVPRAEMIEV:,:VVPOLICE:,:VVGDATBIS:,:VVWERTV:,:VVWAEHRSLV:,:VVNEBENKO:,:VVWAEHRSLN:,:VVNACHNA:,:VVFESTBETR:,:VVVERZOLLT:,:VVKZABRFR:,:VVZAHLART:,:VVZAHLBED:,:VVKZLSPERR:,:VVANAME1:,:VVANAME2:,:VVASTRASSE:,:VVASTRASSE2:,:VVALAND:,:VVAPLZ:,:VVAORT:,:VVABZ:,:VVABZBEZ:,:VVACOUNTY:,:VVACITY:,:VVKUNDNRV:,:VVADRSLV:,:VVKUNDNRE:,:VVEMPFKZ:,:VVADRSLL:,:VVADRSLO:,:VVKUNDNRVF:,:VVADRSLKVF:,:VVADRSLLVF:,:VVKUNDNRR:,:VVADRSLKR:,:VVADRSLLR:,:VVKUNDNRF:,:VVADRSLKF:,:VVADRSLLF:,:VVANTEILF:,:VVPI:,:VVET:,:VVLS:,:VVPA:,:VVLA:,:VVFR:,:VVAV:,:VVDECKBLATT:,:VVLIEFSCHPOS:,:VVLPACKNR:,:VVANZTLIEF:,:VVANZTLIEFR:,:VVANZTLIEFB:,:VVLIEFTERM:,:VVFRACHTBE:,:VVVB:,:VVKZKUNDV:,:VVZONE:,:VVKGBIS:,:VVKDVKL:,:VVADRSLLUR:,:VVVALUTA:,:VVVALDAT:,:VVEKON:,:VVVERSIBE:,:VVVSTK:,:VVLSTKPA:,:VVPAUFKRS:,:VVPAUFLFD:,:VVPAUFPOS:,:VVVERPKOST:,:VVKOSTBGR:,:VVVERPKOSTE:,:VVLIEFNR:,:VVRENR:,:VVREPOS:,:VVREDAT:,:VVFRNETTO:,:VVFRKSTA:,:VVZOLLPAP:,:VVPROGRP:,:VVUEBKZ:,:VVDROFT:,:VVKREDLIM:,:VVSWING:,:VVRAITING:,:VVVERS:,:VVKREDBIS:,:VVKREDVON:,:VVLUEBKZ:,:VVFRDAT:,:VVFRZEIT:,:VVFRBENID:,:VVKUNDNRRE:,:VVLIEFART:,:VVKTRANSDAT:,:VVKTRANSUHR:,:VVKTRANSBEN:,:VVKTRANSSTA:,:VVSTRANSDATA:,:VVSTRANSUHRA:,:VVSTRANSERL:,:VVSTRANSDATE:,:VVSTRANSUHRE:,:VVETRANSDAT:,:VVETRANSUHR:,:VVETRANSBEN:,:VVAKTKZ:,:VVPSTKKZ:,:VVANZVP:,:VVWAEHRSL:,:VVHWAEHRSL:,:VVHEUROKURS:,:VVHEUROKURSVK:,:VVFEUROKURS:,:VVFEUROKURSVK:,:VVLOHNKD:,:VVARCHKZ:,:VVARCHDAT:,:VVARCHBEL:,:VVSEQUNO:,:VVLFDPN:,:VVARTGRP:,:VVAETINEU:,:VVPTARIF:,:VVANSPRECH:,:VVANSPZUS:,:VVTRANSSEQ:,:VVEDI:,:VVEDIDAT:,:VVQUITTAIO:,:VVGESMTR:,:VVLOAD:,:VVLVOR:,:VVUSERFRA:,:VVZEUGNIS:,:VVFILLER:,:VVAENDZL:,:VVAENDBEN:,:VVAENDDAT:,:VVNEUBEN:,:VVNEUDAT:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case "JLT":
                    or1.CommandText = "INSERT INTO VVLIEF ( VVMANDANT,VVLIEFSCH,VVLO,VVPRODST1,VVPRODST2,VVPRODST3,VVPRODST4,VVPRODST5,VVPRODST6,VVPRODST7,VVPRODST8,VVPRODST9,VVLIEFSCHTYP,VVKZINLEXP,VVSTATUS,VVVERSART,VVSPED,VVVERSARTU,VVSPEDU,VVVERSARTV,VVSPEDV,VVEBDAT,VVKZEBBUCH,VVLAND,VVPLZ,VVORT,VVBZ,VVBZBEZ,VVCOUNTY,VVCITY,VVAVISNR,VVFBR,VVLIEFBED,VVKZKOSTBER,VVLANDU,VVPLZU,VVORTU,VVBZU,VVBZBEZU,VVCOUNTYU,VVCITYU,VVLIEFSCHGRP,VVVERSDAT,VVLIEFDAT,VVFIXDAT,VVVERPART,VVGUETERNR,VVKZEINZEL,VVEINZTARA,VVEINZBRUT,VVEINZNET,VVANZ,VVTARA,VVBRUTTO,VVNETTO,VVVOLUMEN,VVANZSTK,VVNETMTR,VVWERT,VVLB1,VVANZPAL1,VVANZAPAL1,VVANZRPAL1,VVLB2,VVANZPAL2,VVANZAPAL2,VVANZRPAL2,VVLB3,VVANZPAL3,VVANZAPAL3,VVANZRPAL3,VVLB4,VVANZPAL4,VVANZAPAL4,VVANZRPAL4,VVLB5,VVANZPAL5,VVANZAPAL5,VVANZRPAL5,VVLB6,VVANZPAL6,VVANZAPAL6,VVANZRPAL6,VVKOLP,VVVPLP,VVTPSTA,VVTPMA1,VVTPMAANZ1,VVTPMA2,VVTPMAANZ2,VVGTBS,VVGTBK,VVKM1,VVGTBZ,VVKM2,VVTARIF1,VVORTKL1,VVFRPFL1,VVLAKL1,VVFRSATZ1,VVFRERRECH1,VVMARGEP1,VVMARGEA1,VVSUMME1,VVTARIF2,VVORTKL2,VVFRPFL2,VVLAKL2,VVFRSATZ2,VVFRERRECH2,VVMARGEP2,VVMARGEA2,VVSUMME2,VVTARIF3,VVORTKL3,VVFRPFL3,VVLAKL3,VVFRSATZ3,VVFRERRECH3,VVMARGEP3,VVMARGEA3,VVSUMME3,VVPRAEMIEV,VVPOLICE,VVGDATBIS,VVWERTV,VVWAEHRSLV,VVNEBENKO,VVWAEHRSLN,VVNACHNA,VVFESTBETR,VVVERZOLLT,VVKZABRFR,VVZAHLART,VVZAHLBED,VVKZLSPERR,VVANAME1,VVANAME2,VVASTRASSE,VVASTRASSE2,VVALAND,VVAPLZ,VVAORT,VVABZ,VVABZBEZ,VVACOUNTY,VVACITY,VVKUNDNRV,VVADRSLV,VVKUNDNRE,VVEMPFKZ,VVADRSLL,VVADRSLO,VVKUNDNRVF,VVADRSLKVF,VVADRSLLVF,VVKUNDNRR,VVADRSLKR,VVADRSLLR,VVKUNDNRF,VVADRSLKF,VVADRSLLF,VVANTEILF,VVPI,VVET,VVLS,VVPA,VVLA,VVFR,VVAV,VVDECKBLATT,VVLIEFSCHPOS,VVLPACKNR,VVANZTLIEF,VVANZTLIEFR,VVANZTLIEFB,VVLIEFTERM,VVFRACHTBE,VVVB,VVKZKUNDV,VVZONE,VVKGBIS,VVKDVKL,VVADRSLLUR,VVVALUTA,VVVALDAT,VVEKON,VVVERSIBE,VVVSTK,VVLSTKPA,VVPAUFKRS,VVPAUFLFD,VVPAUFPOS,VVVERPKOST,VVKOSTBGR,VVVERPKOSTE,VVLIEFNR,VVRENR,VVREPOS,VVREDAT,VVFRNETTO,VVFRKSTA,VVZOLLPAP,VVPROGRP,VVUEBKZ,VVDROFT,VVKREDLIM,VVSWING,VVRAITING,VVVERS,VVKREDBIS,VVKREDVON,VVLUEBKZ,VVFRDAT,VVFRZEIT,VVFRBENID,VVKUNDNRRE,VVLIEFART,VVKTRANSDAT,VVKTRANSUHR,VVKTRANSBEN,VVKTRANSSTA,VVSTRANSDATA,VVSTRANSUHRA,VVSTRANSERL,VVSTRANSDATE,VVSTRANSUHRE,VVETRANSDAT,VVETRANSUHR,VVETRANSBEN,VVAKTKZ,VVPSTKKZ,VVANZVP,VVWAEHRSL,VVHWAEHRSL,VVHEUROKURS,VVHEUROKURSVK,VVFEUROKURS,VVFEUROKURSVK,VVLOHNKD,VVARCHKZ,VVARCHDAT,VVARCHBEL,VVSEQUNO,VVLFDPN,VVARTGRP,VVAETINEU,VVPTARIF,VVANSPRECH,VVANSPZUS,VVTRANSSEQ,VVEDI,VVEDIDAT,VVQUITTAIO,VVGESMTR,VVLOAD,VVLVOR,VVUSERFRA,VVZEUGNIS,VVFILLER,VVAENDZL,VVAENDBEN,VVAENDDAT,VVNEUBEN,VVNEUDAT)"
                   + " VALUES (:VVMANDANT:,:VVLIEFSCH:,:VVLO:,:VVPRODST1:,:VVPRODST2:,:VVPRODST3:,:VVPRODST4:,:VVPRODST5:,:VVPRODST6:,:VVPRODST7:,:VVPRODST8:,:VVPRODST9:,:VVLIEFSCHTYP:,:VVKZINLEXP:,:VVSTATUS:,:VVVERSART:,:VVSPED:,:VVVERSARTU:,:VVSPEDU:,:VVVERSARTV:,:VVSPEDV:,:VVEBDAT:,:VVKZEBBUCH:,:VVLAND:,:VVPLZ:,:VVORT:,:VVBZ:,:VVBZBEZ:,:VVCOUNTY:,:VVCITY:,:VVAVISNR:,:VVFBR:,:VVLIEFBED:,:VVKZKOSTBER:,:VVLANDU:,:VVPLZU:,:VVORTU:,:VVBZU:,:VVBZBEZU:,:VVCOUNTYU:,:VVCITYU:,:VVLIEFSCHGRP:,:VVVERSDAT:,:VVLIEFDAT:,:VVFIXDAT:,:VVVERPART:,:VVGUETERNR:,:VVKZEINZEL:,:VVEINZTARA:,:VVEINZBRUT:,:VVEINZNET:,:VVANZ:,:VVTARA:,:VVBRUTTO:,:VVNETTO:,:VVVOLUMEN:,:VVANZSTK:,:VVNETMTR:,:VVWERT:,:VVLB1:,:VVANZPAL1:,:VVANZAPAL1:,:VVANZRPAL1:,:VVLB2:,:VVANZPAL2:,:VVANZAPAL2:,:VVANZRPAL2:,:VVLB3:,:VVANZPAL3:,:VVANZAPAL3:,:VVANZRPAL3:,:VVLB4:,:VVANZPAL4:,:VVANZAPAL4:,:VVANZRPAL4:,:VVLB5:,:VVANZPAL5:,:VVANZAPAL5:,:VVANZRPAL5:,:VVLB6:,:VVANZPAL6:,:VVANZAPAL6:,:VVANZRPAL6:,:VVKOLP:,:VVVPLP:,:VVTPSTA:,:VVTPMA1:,:VVTPMAANZ1:,:VVTPMA2:,:VVTPMAANZ2:,:VVGTBS:,:VVGTBK:,:VVKM1:,:VVGTBZ:,:VVKM2:,:VVTARIF1:,:VVORTKL1:,:VVFRPFL1:,:VVLAKL1:,:VVFRSATZ1:,:VVFRERRECH1:,:VVMARGEP1:,:VVMARGEA1:,:VVSUMME1:,:VVTARIF2:,:VVORTKL2:,:VVFRPFL2:,:VVLAKL2:,:VVFRSATZ2:,:VVFRERRECH2:,:VVMARGEP2:,:VVMARGEA2:,:VVSUMME2:,:VVTARIF3:,:VVORTKL3:,:VVFRPFL3:,:VVLAKL3:,:VVFRSATZ3:,:VVFRERRECH3:,:VVMARGEP3:,:VVMARGEA3:,:VVSUMME3:,:VVPRAEMIEV:,:VVPOLICE:,:VVGDATBIS:,:VVWERTV:,:VVWAEHRSLV:,:VVNEBENKO:,:VVWAEHRSLN:,:VVNACHNA:,:VVFESTBETR:,:VVVERZOLLT:,:VVKZABRFR:,:VVZAHLART:,:VVZAHLBED:,:VVKZLSPERR:,:VVANAME1:,:VVANAME2:,:VVASTRASSE:,:VVASTRASSE2:,:VVALAND:,:VVAPLZ:,:VVAORT:,:VVABZ:,:VVABZBEZ:,:VVACOUNTY:,:VVACITY:,:VVKUNDNRV:,:VVADRSLV:,:VVKUNDNRE:,:VVEMPFKZ:,:VVADRSLL:,:VVADRSLO:,:VVKUNDNRVF:,:VVADRSLKVF:,:VVADRSLLVF:,:VVKUNDNRR:,:VVADRSLKR:,:VVADRSLLR:,:VVKUNDNRF:,:VVADRSLKF:,:VVADRSLLF:,:VVANTEILF:,:VVPI:,:VVET:,:VVLS:,:VVPA:,:VVLA:,:VVFR:,:VVAV:,:VVDECKBLATT:,:VVLIEFSCHPOS:,:VVLPACKNR:,:VVANZTLIEF:,:VVANZTLIEFR:,:VVANZTLIEFB:,:VVLIEFTERM:,:VVFRACHTBE:,:VVVB:,:VVKZKUNDV:,:VVZONE:,:VVKGBIS:,:VVKDVKL:,:VVADRSLLUR:,:VVVALUTA:,:VVVALDAT:,:VVEKON:,:VVVERSIBE:,:VVVSTK:,:VVLSTKPA:,:VVPAUFKRS:,:VVPAUFLFD:,:VVPAUFPOS:,:VVVERPKOST:,:VVKOSTBGR:,:VVVERPKOSTE:,:VVLIEFNR:,:VVRENR:,:VVREPOS:,:VVREDAT:,:VVFRNETTO:,:VVFRKSTA:,:VVZOLLPAP:,:VVPROGRP:,:VVUEBKZ:,:VVDROFT:,:VVKREDLIM:,:VVSWING:,:VVRAITING:,:VVVERS:,:VVKREDBIS:,:VVKREDVON:,:VVLUEBKZ:,:VVFRDAT:,:VVFRZEIT:,:VVFRBENID:,:VVKUNDNRRE:,:VVLIEFART:,:VVKTRANSDAT:,:VVKTRANSUHR:,:VVKTRANSBEN:,:VVKTRANSSTA:,:VVSTRANSDATA:,:VVSTRANSUHRA:,:VVSTRANSERL:,:VVSTRANSDATE:,:VVSTRANSUHRE:,:VVETRANSDAT:,:VVETRANSUHR:,:VVETRANSBEN:,:VVAKTKZ:,:VVPSTKKZ:,:VVANZVP:,:VVWAEHRSL:,:VVHWAEHRSL:,:VVHEUROKURS:,:VVHEUROKURSVK:,:VVFEUROKURS:,:VVFEUROKURSVK:,:VVLOHNKD:,:VVARCHKZ:,:VVARCHDAT:,:VVARCHBEL:,:VVSEQUNO:,:VVLFDPN:,:VVARTGRP:,:VVAETINEU:,:VVPTARIF:,:VVANSPRECH:,:VVANSPZUS:,:VVTRANSSEQ:,:VVEDI:,:VVEDIDAT:,:VVQUITTAIO:,:VVGESMTR:,:VVLOAD:,:VVLVOR:,:VVUSERFRA:,:VVZEUGNIS:,:VVFILLER:,:VVAENDZL:,:VVAENDBEN:,:VVAENDDAT:,:VVNEUBEN:,:VVNEUDAT:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
            }
            Connect2Proxy(or1);
        }

        public DataSet QueryVVLIEF(DataRow dwData, int option = 1)
        { 
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM VVLIEF WHERE  ROWNUM<2 ";
                    break;
                case 1:
                    or1.CommandText = "SELECT * FROM VVLIEF WHERE VVMANDANT=:VVMANDANT: AND VVLIEFSCH=:VVLIEFSCH:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 2:
                    or1.CommandText = "SELECT DISTINCT R.VRPRENR,VRPREPOS,VRPAUFKRS,VRPAUFLFD,VRPAUFPOS,VV.* "
                  + " FROM VRPOS R JOIN VVLIEF VV ON R.VRPLIEFSCH=VV.VVLIEFSCH"
                  + " WHERE VRPMANDANT=:VRPMANDANT: AND VRPRENR = :VRPRENR:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 3:
                    or1.CommandText = "SELECT V.* FROM VVLIEF V JOIN VVTLIEF T ON V.VVMANDANT=VVTMANDANT AND VVLIEFSCH=VVTLIEFSCH "
                  + " WHERE VVTMANDANT=:VVTMANDANT: AND VVTAUFKRS = :VVTAUFKRS: AND VVTAUFLFD=:VVTAUFLFD:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 4:
                    or1.CommandText = "SELECT DISTINCT 0 AS DUEAMOUNT, KDKUNDNA,KDNAME1,VRKFAELLIG,VKKBESTNR,VKPPOSTYP,VKPAUFKRS,VKPAUFLFD,VKPAUFPOS,VKPART,VKPFARBE,VKPKDARTNR,VKPKDFARBNR,VVLIEFSCH,GPAPARTIE,GPASPPART,GPAFBPART,VVFRDAT,VVTNETKG*0.01 AS VVTNETKG ,VRPMENGE*0.01 AS VRPMENGE,VKPPREIS*0.001 AS VKPPREISX,VRPMEEH,VKKHWAEHRSL||'/'||VKPPREH AS PUM,VRPGESWERT*0.001 AS VRPGESWERT,VRPWAWERT*0.001 AS VRPWAWERT,GLOAMICUC*0.01 AS GLOAMICUC FROM VRPOS VRP JOIN VRKOPF VRK ON VRKMANDANT=VRPMANDANT AND VRKRENR=VRPRENR JOIN VKPOS VKP ON VKPMANDANT=VRPMANDANT AND VRPAUFKRS=VKPAUFKRS AND VRPAUFLFD=VKPAUFLFD AND VRPAUFPOS=VKPAUFPOS JOIN VKKOPF VKK ON VKKMANDANT=VKPMANDANT AND VKKAUFKRS=VKPAUFKRS AND VKKAUFLFD=VKPAUFLFD JOIN KDSTAMM KD ON VKKMANDANT=KDMANDANT AND VKKKUNDNR=KDKUNDNR JOIN VVLIEF VV ON VVMANDANT=VRPMANDANT AND VVLIEFSCH=VRPLIEFSCH JOIN VVTLIEF VVT ON VVTMANDANT=VRPMANDANT AND VVTLIEFSCH=VRPLIEFSCH AND VVTAUFKRS=VKPAUFKRS AND VVTAUFLFD=VKPAUFLFD AND VVTAUFPOS=VKPAUFPOS JOIN GPACK GP ON GPAMANDANT=VVTMANDANT AND GPALIEFSCH=VRPLIEFSCH   AND GPAAUFKRS=VKPAUFKRS AND GPAAUFLFD=VKPAUFLFD AND GPAAUFPOS=VKPAUFPOS LEFT JOIN GLOPITEM ON GLOMANDANT=VKKMANDANT AND GLOITEM=VKKOPITEM "
                        + " WHERE VVTMANDANT=:VVTMANDANT AND VVFRDAT >= :VVFRDAT";
                    or1.Parameters.Add("VVTMANDANT", OracleType.NVarChar).Value = dwData["VVTMANDANT"].ToString();
                    or1.Parameters.Add("VVFRDAT", OracleType.NVarChar).Value = dwData["DEND"].ToString();
                    break;
                case 5:
                    or1.CommandText = "SELECT DISTINCT V.* FROM VVLIEF V JOIN VVTLIEF ON VVTLIEFSCH=VVLIEFSCH JOIN VKPOS P ON VKPAUFKRS=VVTAUFKRS AND VKPAUFLFD=VVTAUFLFD AND VKPAUFPOS=VVTAUFPOS AND VKPSA='  ' WHERE VVNEUDAT>='" + dwData["DSTART"].ToString() + "' AND VVNEUDAT<='" + dwData["DEND"].ToString() + "' AND VVSTATUS IN (" + dwData["C20"].ToString() + ")";
                    break;
                case 6: 
                    or1.CommandText = "SELECT MIN(C.VKPWUTERM) AS VKPWUTERM,MIN(C.VKPLIEFTERM) AS VKPLIEFTERM, "
                        + " A.VVAVISNR,A.VVLIEFSCH,C.VKPAUFKRS,C.VKPAUFLFD,C.VKPAUFPOS,G.KDKNAME, "
                        + " C.VKPART,C.VKPFARBE,D.VKKBESTNR,A.VVADRSLL,COUNT(*) AS PACKNR, "
                        + " MAX(C.VKPMENGE1 * 0.1) AS VKPMENGE1,MAX(C.VKPKDKOMM) AS VKPKDKOMM, "
                        + " ROUND(SUM(F.GPAKG) * 0.001, 2) AS VVKG,ROUND(SUM(F.GPAKGNET) * 0.001, 2) AS VVNETKG, "
                        + " F.GPAKG * 0.001 AS PACKNET,SUM(F.GPAKG) * 0.001 AS PACKGROSS, "
                        + " F.GPASPPART,F.GPAFBPART,F.GPABEM "
                        + " FROM VVLIEF A,VVTLIEF B,VKPOS C,VKKOPF D,VVPACK E,GPACK F,KDSTAMM G,KUNDADR H "
                        + " WHERE A.VVMANDANT = B.VVTMANDANT AND A.VVLIEFSCH = B.VVTLIEFSCH "
                        + " AND B.VVTMANDANT = C.VKPMANDANT AND B.VVTAUFKRS = C.VKPAUFKRS "
                        + " AND B.VVTAUFLFD = C.VKPAUFLFD AND B.VVTAUFPOS = C.VKPAUFPOS "
                        + " AND C.VKPMANDANT = D.VKKMANDANT AND C.VKPSA = D.VKKSA  "
                        + " AND C.VKPAUFKRS = D.VKKAUFKRS AND C.VKPAUFLFD = D.VKKAUFLFD "
                        + " AND A.VVMANDANT = E.VVPMANDANT AND A.VVLIEFSCH = E.VVPLIEFSCH  "
                        + " AND F.GPALIEFSCH = E.VVPLIEFSCH AND F.GPATEILNR = B.VVTTEILNR "
                        + " AND F.GPAPACKNR = E.VVPPACKNR AND F.GPAAUFKRS = B.VVTAUFKRS "
                        + " AND F.GPAAUFLFD = B.VVTAUFLFD AND F.GPAAUFPOS = B.VVTAUFPOS "
                        + " AND A.VVMANDANT = G.KDMANDANT AND A.VVKUNDNRE = G.KDKUNDNR "
                        + " AND A.VVMANDANT = H.KDAMANDANT(+) AND A.VVKUNDNRE = H.KDAKUNDNR(+) "
                        + " AND A.VVADRSLL = H.KDAADRSL(+) "
                        + " AND A.VVNEUDAT >= '" + dwData["DSTART"].ToString() + "' "
                        + " AND A.VVNEUDAT <= '" + dwData["DEND"].ToString() + "' "
                        + " AND C.VKPSA = '  ' "
                        + " AND A.VVSTATUS IN (" + dwData["C20"].ToString() + ") "
                        + " GROUP BY A.VVAVISNR,A.VVLIEFSCH,C.VKPAUFKRS,C.VKPAUFLFD,C.VKPAUFPOS,G.KDKNAME, "
                        + " A.VVADRSLL,C.VKPART,C.VKPFARBE,F.GPASPPART,F.GPAKG,F.GPAFBPART,F.GPABEM,D.VKKBESTNR "
                        + " ORDER BY VVAVISNR, VVLIEFSCH, VKPAUFKRS, VKPAUFLFD, VKPAUFPOS, PACKNR DESC ";

                    break;
                case 7: 
                    or1.CommandText = "SELECT MIN(c.VKPWUTERM) AS VKPWUTERM, MIN(c.VKPLIEFTERM) AS VKPLIEFTERM, "
                        + " a.VVAVISNR,a.VVLIEFSCH,c.VKPAUFKRS,c.VKPAUFLFD,c.VKPAUFPOS,h.KDKNAME,c.VKPART, "
                        + " c.VKPFARBE,d.VKKBESTNR,a.VVADRSLL,COUNT(*) AS PACKNR,MAX(c.VKPMENGE1 * 0.1) AS VKPMENGE1, "
                        + " MAX(c.VKPKDKOMM) AS VKPKDKOMM,ROUND(SUM(e.ZUEINTKG) * 0.001, 2) AS VVKG, "
                        + " ROUND(SUM(e.ZUEINTKG) * 0.001, 2) AS VVNETKG,e.ZUEINTKG * 0.001 AS PACKNET, "
                        + " SUM(e.ZUEINTKG) * 0.001 AS PACKGROSS,g.GPSPPART AS GPASPPART, "
                        + " g.GPFBPART AS GPAFBPART, "
                        + " f.GLBEM AS GPABEM "
                        + "   FROM VVLIEF A,VVTLIEF B,VKPOS C,VKKOPF D,ZUTEI E,GLLG F,GPDAT G,KDSTAMM H,KUNDADR I "
                        + "  WHERE A.VVMANDANT = B.VVTMANDANT AND VVTLIEFSCH = VVLIEFSCH "
                        + "    AND B.VVTMANDANT = C.VKPMANDANT AND B.VVTAUFKRS = C.VKPAUFKRS "
                        + "    AND B.VVTAUFLFD = C.VKPAUFLFD AND B.VVTAUFPOS = C.VKPAUFPOS "
                        + "    AND C.VKPMANDANT = D.VKKMANDANT AND C.VKPAUFKRS = D.VKKAUFKRS "
                        + "    AND C.VKPAUFLFD = D.VKKAUFLFD AND C.VKPSA = D.VKKSA "
                        + "    AND B.VVTMANDANT = E.ZUMANDANT AND B.VVTAUFKRS = E.ZUAUFKRS   "
                        + "    AND B.VVTAUFLFD = E.ZUAUFLFD AND B.VVTAUFPOS = E.ZUAUFPOS "
                        + "    AND B.VVTTEILNR = E.ZUTEILNR AND E.ZUMANDANT = F.GLMANDANT "
                        + "    AND E.ZUPARTIE = F.GLPARTIE AND E.ZUPARTIEKZ = F.GLPARTIEKZ "
                        + "    AND E.ZULBEHI = F.GLLBEHI AND F.GLMANDANT = G.GPMANDANT "
                        + "    AND F.GLPARTIE = G.GPPARTIE AND F.GLPARTIEKZ = G.GPPARTIEKZ "
                        + "    AND A.VVMANDANT = H.KDMANDANT AND A.VVKUNDNRE = H.KDKUNDNR "
                        + "    AND A.VVMANDANT = I.KDAMANDANT(+) AND A.VVKUNDNRE = I.KDAKUNDNR(+) "
                        + "    AND A.VVADRSLL = I.KDAADRSL(+)  "
                        + "    AND C.VKPSA = '  ' AND F.GLLB = 'CP' "
                        + "    AND A.VVNEUDAT >= '" + dwData["DSTART"].ToString() + "' "
                        + "    AND A.VVNEUDAT <= '" + dwData["DEND"].ToString() + "' "
                        + "    AND A.VVSTATUS IN (" + dwData["C20"].ToString() + ") "
                        + "  GROUP BY a.VVAVISNR, a.VVLIEFSCH,c.VKPAUFKRS,c.VKPAUFLFD,c.VKPAUFPOS,e.ZUEINTKG, "
                        + " h.KDKNAME, a.VVADRSLL,c.VKPART,c.VKPFARBE,g.GPSPPART,g.GPFBPART, "
                        + " f.GLBEM,d.VKKBESTNR  "
                        + "  ORDER BY VVAVISNR, VVLIEFSCH, VKPAUFKRS, VKPAUFLFD, VKPAUFPOS, PACKNR DESC ";
                    break;
                case 8:
                    or1.CommandText = "SELECT DISTINCT VVLIEFSCH,VVLIEFSCH AS KEY,VVTAUFTYP,VVTAUFKRS,VVTAUFLFD FROM VVLIEF V JOIN VVTLIEF T ON V.VVMANDANT=VVTMANDANT AND VVLIEFSCH=VVTLIEFSCH "
                    + " WHERE VVTMANDANT=:VVTMANDANT: AND VVTAUFTYP=:VVTAUFTYP: AND VVTAUFKRS = :VVTAUFKRS: AND VVTAUFLFD=:VVTAUFLFD: AND VVTLIEFSCH LIKE '" + dwData["VVTLIEFSCH"].ToString() + "%'  ORDER BY 1 DESC";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 9:
                    or1.CommandText = "SELECT DISTINCT V.* FROM VVLIEF V JOIN VVTLIEF T ON V.VVMANDANT=VVTMANDANT AND VVLIEFSCH=VVTLIEFSCH  "
                    + " WHERE VVTMANDANT=:VVTMANDANT: AND VVTAUFTYP=:VVTAUFTYP: AND VVTAUFKRS = :VVTAUFKRS: AND VVTAUFLFD=:VVTAUFLFD: "
                    + " ORDER BY 1 DESC";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 10:
                    or1.CommandText = "SELECT V.VVLIEFSCH,V.VVVERSART,V.VVSPED,TRIM(V.VVANAME1)||TRIM(VVANAME2) AS VVNAME, "
                        + " TRIM(V.VVASTRASSE)||TRIM(V.VVASTRASSE2) AS VVADR,TRIM(V.VVABZBEZ) AS VVSTAFF,TRIM(VVAORT) AS VVTEL,VVNEUDAT,VVVERSDAT, "
                        + " A.VKKAUFART,A.VKKAUFKRS || '-' || to_number(A.VKKAUFLFD) as ORDERNO,vkkbestnr AS CUPO,A.VKKKUNDNR,K.KDKUNDNA,  "
                        + " trim(K.KDNAME1) || trim(K.KDNAME2) as CUSTOMER,trim(K.KDSTRASSE1) || trim(K.KDSTRASSE2) AS CUSTADR,  "
                        + " (SELECT TRIM(X.VKALNAME1)||TRIM(X.VKALNAME2) FROM VKADR X WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA  "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000') AS DELNAME,   "
                        + " (SELECT TRIM(X.VKALSTRASSE1)||TRIM(X.VKALSTRASSE2) FROM VKADR X WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA  "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000') AS DELADR,   "
                        + " (SELECT TRIM(X.VKALBZBEZ) FROM VKADR X WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA  "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000') AS DELSTAFF,   "
                        + " (SELECT REPLACE(TRIM(X.VKALORT),':','/') FROM VKADR X WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA  "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000') AS DELTEL,  "
                        + " (SELECT TRIM(T.KDANAME1)||TRIM(T.KDANAME2) FROM VKADR X,KUNDADR T WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA  "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000' AND X.VKAMANDANT = T.KDAMANDANT  "
                        + " AND X.VKAKUNDNR3 = T.KDAKUNDNR AND X.VKAADRSL3 = T.KDAADRSL) AS INVNAME,  "
                        + " (SELECT TRIM(T.KDASTRASSE1)||TRIM(T.KDASTRASSE2) FROM VKADR X,KUNDADR T WHERE X.VKAMANDANT = A.VKKMANDANT AND X.VKASA = A.VKKSA  "
                        + " AND X.VKAAUFKRS = A.VKKAUFKRS AND X.VKAAUFLFD = A.VKKAUFLFD AND X.VKAAUFPOS = '000' AND X.VKAMANDANT = T.KDAMANDANT  "
                        + " AND X.VKAKUNDNR3 = T.KDAKUNDNR AND X.VKAADRSL3 = T.KDAADRSL) AS INVADR,   "
                        + " (select trim(substr(sddaten, 2, 20)) from sddat t where sdsa = '0149' and sdkey like a.vkkmandant || a.vkkhwaehrsl || '%') as CURRENCY,  "
                        + " (SELECT TRIM(SUBSTR(SDDATEN, 52, 6)) FROM SDDAT WHERE SDSA = '0192' AND SDKEY LIKE A.VKKMANDANT || A.VKKVG || '%V') AS ACCOUNT,  "
                        + " trim(z.zabbez) as PAYMENT,A.VKKANSPRECH AS CUSTAFF,D.KDSTEL AS CUTEL,A.VKKSACHBE AS STAFF,TRIM(I.EXCELFILE) AS NAM,  "
                        + " TRIM(I.NETDRIVE) AS MOB,TRIM(I.ROOTDRIVE) AS TEL,TRIM(I.UPDATER) AS MAIL,A.VKKNEUDAT, "
                        + " (SELECT VVAFAHRER FROM VVAVIS WHERE VVAMANDANT = V.VVMANDANT AND  VVAAVISNR = V.VVAVISNR ) AS EXNO "
                        + " FROM VKKOPF A,KDSTAMM K,ZABED Z,KDANSP D,ICC_HRSTAMM I,VVLIEF V "
                        + " WHERE A.VKKMANDANT=V.VVMANDANT AND a.VKKAUFKRS=:VVPAUFKRS: AND a.VKKAUFLFD=:VVPAUFLFD: "
                        + " AND A.VKKMANDANT = K.KDMANDANT AND A.VKKKUNDNR = K.KDKUNDNR  "
                        + " AND A.VKKSA = '  ' AND A.VKKMANDANT = Z.ZABMANDANT AND a.vkkzahlbed = z.zabnr  "
                        + " and Z.zabsprachkz = 'V ' AND A.VKKMANDANT = D.KDSMANDANT(+) AND A.VKKKUNDNR = D.KDSKUNDNR(+)  "
                        + " AND A.VKKANSPRECH = D.KDSANSPNA(+) AND A.VKKMANDANT = I.MANDANT(+) AND trim(A.VKKSACHBE) = trim(I.USERID(+)) "
                        + " AND V.VVMANDANT=:VVMANDANT: AND V.VVLIEFSCH =:VVLIEFSCH: ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                default:
                    break;
            }
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }

        public void UpdateVVLIEF(DataRow dwData, int option = 1)
        {
            if (dwData != null)
            {
                dwData["VVAENDBEN"] = app.User;
                dwData["VVAENDDAT"] = date;
            }
            if (option == 0)
            {
                switch (app.company)
                {
                    case "YGR":
                    case "TST":
                    default:
                        option = 1;
                        break;
                    case "JLT":
                        option = 3;
                        break;
                }
            }
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "UPDATE VVLIEF SET VVMANDANT=:VVMANDANT:,VVLIEFSCH=:VVLIEFSCH:,VVLO=:VVLO:,VVPRODST1=:VVPRODST1:,VVPRODST2=:VVPRODST2:,VVPRODST3=:VVPRODST3:,VVPRODST4=:VVPRODST4:,VVPRODST5=:VVPRODST5:,VVPRODST6=:VVPRODST6:,VVPRODST7=:VVPRODST7:,VVPRODST8=:VVPRODST8:,VVPRODST9=:VVPRODST9:,VVLIEFSCHTYP=:VVLIEFSCHTYP:,VVKZINLEXP=:VVKZINLEXP:,VVSTATUS=:VVSTATUS:,VVVERSART=:VVVERSART:,VVSPED=:VVSPED:,VVVERSARTU=:VVVERSARTU:,VVSPEDU=:VVSPEDU:,VVVERSARTV=:VVVERSARTV:,VVSPEDV=:VVSPEDV:,VVEBDAT=:VVEBDAT:,VVKZEBBUCH=:VVKZEBBUCH:,VVLAND=:VVLAND:,VVPLZ=:VVPLZ:,VVORT=:VVORT:,VVBZ=:VVBZ:,VVBZBEZ=:VVBZBEZ:,VVCOUNTY=:VVCOUNTY:,VVCITY=:VVCITY:,VVAVISNR=:VVAVISNR:,VVFBR=:VVFBR:,VVLIEFBED=:VVLIEFBED:,VVKZKOSTBER=:VVKZKOSTBER:,VVLANDU=:VVLANDU:,VVPLZU=:VVPLZU:,VVORTU=:VVORTU:,VVBZU=:VVBZU:,VVBZBEZU=:VVBZBEZU:,VVCOUNTYU=:VVCOUNTYU:,VVCITYU=:VVCITYU:,VVLIEFSCHGRP=:VVLIEFSCHGRP:,VVVERSDAT=:VVVERSDAT:,VVLIEFDAT=:VVLIEFDAT:,VVFIXDAT=:VVFIXDAT:,VVVERPART=:VVVERPART:,VVGUETERNR=:VVGUETERNR:,VVKZEINZEL=:VVKZEINZEL:,VVEINZTARA=:VVEINZTARA:,VVEINZBRUT=:VVEINZBRUT:,VVEINZNET=:VVEINZNET:,VVANZ=:VVANZ:,VVTARA=:VVTARA:,VVBRUTTO=:VVBRUTTO:,VVNETTO=:VVNETTO:,VVVOLUMEN=:VVVOLUMEN:,VVANZSTK=:VVANZSTK:,VVNETMTR=:VVNETMTR:,VVWERT=:VVWERT:,VVLB1=:VVLB1:,VVANZPAL1=:VVANZPAL1:,VVANZAPAL1=:VVANZAPAL1:,VVANZRPAL1=:VVANZRPAL1:,VVLB2=:VVLB2:,VVANZPAL2=:VVANZPAL2:,VVANZAPAL2=:VVANZAPAL2:,VVANZRPAL2=:VVANZRPAL2:,VVLB3=:VVLB3:,VVANZPAL3=:VVANZPAL3:,VVANZAPAL3=:VVANZAPAL3:,VVANZRPAL3=:VVANZRPAL3:,VVLB4=:VVLB4:,VVANZPAL4=:VVANZPAL4:,VVANZAPAL4=:VVANZAPAL4:,VVANZRPAL4=:VVANZRPAL4:,VVLB5=:VVLB5:,VVANZPAL5=:VVANZPAL5:,VVANZAPAL5=:VVANZAPAL5:,VVANZRPAL5=:VVANZRPAL5:,VVLB6=:VVLB6:,VVANZPAL6=:VVANZPAL6:,VVANZAPAL6=:VVANZAPAL6:,VVANZRPAL6=:VVANZRPAL6:,VVKOLP=:VVKOLP:,VVVPLP=:VVVPLP:,VVTPSTA=:VVTPSTA:,VVTPMA1=:VVTPMA1:,VVTPMAANZ1=:VVTPMAANZ1:,VVTPMA2=:VVTPMA2:,VVTPMAANZ2=:VVTPMAANZ2:,VVGTBS=:VVGTBS:,VVGTBK=:VVGTBK:,VVKM1=:VVKM1:,VVGTBZ=:VVGTBZ:,VVKM2=:VVKM2:,VVTARIF1=:VVTARIF1:,VVORTKL1=:VVORTKL1:,VVFRPFL1=:VVFRPFL1:,VVLAKL1=:VVLAKL1:,VVFRSATZ1=:VVFRSATZ1:,VVFRERRECH1=:VVFRERRECH1:,VVMARGEP1=:VVMARGEP1:,VVMARGEA1=:VVMARGEA1:,VVSUMME1=:VVSUMME1:,VVTARIF2=:VVTARIF2:,VVORTKL2=:VVORTKL2:,VVFRPFL2=:VVFRPFL2:,VVLAKL2=:VVLAKL2:,VVFRSATZ2=:VVFRSATZ2:,VVFRERRECH2=:VVFRERRECH2:,VVMARGEP2=:VVMARGEP2:,VVMARGEA2=:VVMARGEA2:,VVSUMME2=:VVSUMME2:,VVTARIF3=:VVTARIF3:,VVORTKL3=:VVORTKL3:,VVFRPFL3=:VVFRPFL3:,VVLAKL3=:VVLAKL3:,VVFRSATZ3=:VVFRSATZ3:,VVFRERRECH3=:VVFRERRECH3:,VVMARGEP3=:VVMARGEP3:,VVMARGEA3=:VVMARGEA3:,VVSUMME3=:VVSUMME3:,VVPRAEMIEV=:VVPRAEMIEV:,VVPOLICE=:VVPOLICE:,VVGDATBIS=:VVGDATBIS:,VVWERTV=:VVWERTV:,VVWAEHRSLV=:VVWAEHRSLV:,VVNEBENKO=:VVNEBENKO:,VVWAEHRSLN=:VVWAEHRSLN:,VVNACHNA=:VVNACHNA:,VVFESTBETR=:VVFESTBETR:,VVVERZOLLT=:VVVERZOLLT:,VVKZABRFR=:VVKZABRFR:,VVZAHLART=:VVZAHLART:,VVZAHLBED=:VVZAHLBED:,VVKZLSPERR=:VVKZLSPERR:,VVANAME1=:VVANAME1:,VVANAME2=:VVANAME2:,VVASTRASSE=:VVASTRASSE:,VVASTRASSE2=:VVASTRASSE2:,VVALAND=:VVALAND:,VVAPLZ=:VVAPLZ:,VVAORT=:VVAORT:,VVABZ=:VVABZ:,VVABZBEZ=:VVABZBEZ:,VVACOUNTY=:VVACOUNTY:,VVACITY=:VVACITY:,VVKUNDNRV=:VVKUNDNRV:,VVADRSLV=:VVADRSLV:,VVKUNDNRE=:VVKUNDNRE:,VVEMPFKZ=:VVEMPFKZ:,VVADRSLL=:VVADRSLL:,VVADRSLO=:VVADRSLO:,VVKUNDNRVF=:VVKUNDNRVF:,VVADRSLKVF=:VVADRSLKVF:,VVADRSLLVF=:VVADRSLLVF:,VVKUNDNRR=:VVKUNDNRR:,VVADRSLKR=:VVADRSLKR:,VVADRSLLR=:VVADRSLLR:,VVKUNDNRF=:VVKUNDNRF:,VVADRSLKF=:VVADRSLKF:,VVADRSLLF=:VVADRSLLF:,VVANTEILF=:VVANTEILF:,VVPI=:VVPI:,VVET=:VVET:,VVLS=:VVLS:,VVPA=:VVPA:,VVLA=:VVLA:,VVFR=:VVFR:,VVAV=:VVAV:,VVDECKBLATT=:VVDECKBLATT:,VVLIEFSCHPOS=:VVLIEFSCHPOS:,VVLPACKNR=:VVLPACKNR:,VVANZTLIEF=:VVANZTLIEF:,VVANZTLIEFR=:VVANZTLIEFR:,VVANZTLIEFB=:VVANZTLIEFB:,VVLIEFTERM=:VVLIEFTERM:,VVFRACHTBE=:VVFRACHTBE:,VVVB=:VVVB:,VVKZKUNDV=:VVKZKUNDV:,VVZONE=:VVZONE:,VVKGBIS=:VVKGBIS:,VVKDVKL=:VVKDVKL:,VVADRSLLUR=:VVADRSLLUR:,VVVALUTA=:VVVALUTA:,VVVALDAT=:VVVALDAT:,VVEKON=:VVEKON:,VVVERSIBE=:VVVERSIBE:,VVVSTK=:VVVSTK:,VVLSTKPA=:VVLSTKPA:,VVPAUFKRS=:VVPAUFKRS:,VVPAUFLFD=:VVPAUFLFD:,VVPAUFPOS=:VVPAUFPOS:,VVVERPKOST=:VVVERPKOST:,VVKOSTBGR=:VVKOSTBGR:,VVVERPKOSTE=:VVVERPKOSTE:,VVLIEFNR=:VVLIEFNR:,VVRENR=:VVRENR:,VVREPOS=:VVREPOS:,VVREDAT=:VVREDAT:,VVFRNETTO=:VVFRNETTO:,VVFRKSTA=:VVFRKSTA:,VVZOLLPAP=:VVZOLLPAP:,VVPROGRP=:VVPROGRP:,VVUEBKZ=:VVUEBKZ:,VVDROFT=:VVDROFT:,VVKREDLIM=:VVKREDLIM:,VVSWING=:VVSWING:,VVRAITING=:VVRAITING:,VVVERS=:VVVERS:,VVKREDBIS=:VVKREDBIS:,VVKREDVON=:VVKREDVON:,VVLUEBKZ=:VVLUEBKZ:,VVFRDAT=:VVFRDAT:,VVFRZEIT=:VVFRZEIT:,VVFRBENID=:VVFRBENID:,VVKUNDNRRE=:VVKUNDNRRE:,VVLIEFART=:VVLIEFART:,VVKTRANSDAT=:VVKTRANSDAT:,VVKTRANSUHR=:VVKTRANSUHR:,VVKTRANSBEN=:VVKTRANSBEN:,VVKTRANSSTA=:VVKTRANSSTA:,VVSTRANSDATA=:VVSTRANSDATA:,VVSTRANSUHRA=:VVSTRANSUHRA:,VVSTRANSERL=:VVSTRANSERL:,VVSTRANSDATE=:VVSTRANSDATE:,VVSTRANSUHRE=:VVSTRANSUHRE:,VVETRANSDAT=:VVETRANSDAT:,VVETRANSUHR=:VVETRANSUHR:,VVETRANSBEN=:VVETRANSBEN:,VVAKTKZ=:VVAKTKZ:,VVPSTKKZ=:VVPSTKKZ:,VVANZVP=:VVANZVP:,VVWAEHRSL=:VVWAEHRSL:,VVHWAEHRSL=:VVHWAEHRSL:,VVHEUROKURS=:VVHEUROKURS:,VVHEUROKURSVK=:VVHEUROKURSVK:,VVFEUROKURS=:VVFEUROKURS:,VVFEUROKURSVK=:VVFEUROKURSVK:,VVLOHNKD=:VVLOHNKD:,VVARCHKZ=:VVARCHKZ:,VVARCHDAT=:VVARCHDAT:,VVARCHBEL=:VVARCHBEL:,VVSEQUNO=:VVSEQUNO:,VVLFDPN=:VVLFDPN:,VVARTGRP=:VVARTGRP:,VVAETINEU=:VVAETINEU:,VVPTARIF=:VVPTARIF:,VVANSPRECH=:VVANSPRECH:,VVANSPZUS=:VVANSPZUS:,VVTRANSSEQ=:VVTRANSSEQ:,VVEDI=:VVEDI:,VVEDIDAT=:VVEDIDAT:,VVQUITTAIO=:VVQUITTAIO:,VVGESMTR=:VVGESMTR:,VVLOAD=:VVLOAD:,VVLVOR=:VVLVOR:,VVUSERFRA=:VVUSERFRA:,VVZEUGNIS=:VVZEUGNIS:,VVFILLER=:VVFILLER:,VVAENDZL=:VVAENDZL:,VVAENDBEN=:VVAENDBEN:,VVAENDDAT=:VVAENDDAT:,VVNEUBEN=:VVNEUBEN:,VVNEUDAT=:VVNEUDAT:"
                        + " WHERE VVMANDANT=:VVMANDANT: AND VVLIEFSCH=:VVLIEFSCH:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);

                    break;
                case 2:
                    #region====Command====
                    or1.CommandText = "UPDATE VVLIEF SET  VVSEQUNO=:VVSEQUNO:, VVORTU=:VVORTU:, VVBZBEZU=:VVBZBEZU:, VVRAITING=:VVRAITING: "
                    + " WHERE   VVLIEFSCH=:VVLIEFSCH:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    #endregion
                    break;
                case 3:
                    or1.CommandText = "UPDATE VVLIEF SET VVMANDANT=:VVMANDANT:,VVLIEFSCH=:VVLIEFSCH:,VVLO=:VVLO:,VVPRODST1=:VVPRODST1:,VVPRODST2=:VVPRODST2:,VVPRODST3=:VVPRODST3:,VVPRODST4=:VVPRODST4:,VVPRODST5=:VVPRODST5:,VVPRODST6=:VVPRODST6:,VVPRODST7=:VVPRODST7:,VVPRODST8=:VVPRODST8:,VVPRODST9=:VVPRODST9:,VVLIEFSCHTYP=:VVLIEFSCHTYP:,VVKZINLEXP=:VVKZINLEXP:,VVSTATUS=:VVSTATUS:,VVVERSART=:VVVERSART:,VVSPED=:VVSPED:,VVVERSARTU=:VVVERSARTU:,VVSPEDU=:VVSPEDU:,VVVERSARTV=:VVVERSARTV:,VVSPEDV=:VVSPEDV:,VVEBDAT=:VVEBDAT:,VVKZEBBUCH=:VVKZEBBUCH:,VVLAND=:VVLAND:,VVPLZ=:VVPLZ:,VVORT=:VVORT:,VVBZ=:VVBZ:,VVBZBEZ=:VVBZBEZ:,VVCOUNTY=:VVCOUNTY:,VVCITY=:VVCITY:,VVAVISNR=:VVAVISNR:,VVFBR=:VVFBR:,VVLIEFBED=:VVLIEFBED:,VVKZKOSTBER=:VVKZKOSTBER:,VVLANDU=:VVLANDU:,VVPLZU=:VVPLZU:,VVORTU=:VVORTU:,VVBZU=:VVBZU:,VVBZBEZU=:VVBZBEZU:,VVCOUNTYU=:VVCOUNTYU:,VVCITYU=:VVCITYU:,VVLIEFSCHGRP=:VVLIEFSCHGRP:,VVVERSDAT=:VVVERSDAT:,VVLIEFDAT=:VVLIEFDAT:,VVFIXDAT=:VVFIXDAT:,VVVERPART=:VVVERPART:,VVGUETERNR=:VVGUETERNR:,VVKZEINZEL=:VVKZEINZEL:,VVEINZTARA=:VVEINZTARA:,VVEINZBRUT=:VVEINZBRUT:,VVEINZNET=:VVEINZNET:,VVANZ=:VVANZ:,VVTARA=:VVTARA:,VVBRUTTO=:VVBRUTTO:,VVNETTO=:VVNETTO:,VVVOLUMEN=:VVVOLUMEN:,VVANZSTK=:VVANZSTK:,VVNETMTR=:VVNETMTR:,VVWERT=:VVWERT:,VVLB1=:VVLB1:,VVANZPAL1=:VVANZPAL1:,VVANZAPAL1=:VVANZAPAL1:,VVANZRPAL1=:VVANZRPAL1:,VVLB2=:VVLB2:,VVANZPAL2=:VVANZPAL2:,VVANZAPAL2=:VVANZAPAL2:,VVANZRPAL2=:VVANZRPAL2:,VVLB3=:VVLB3:,VVANZPAL3=:VVANZPAL3:,VVANZAPAL3=:VVANZAPAL3:,VVANZRPAL3=:VVANZRPAL3:,VVLB4=:VVLB4:,VVANZPAL4=:VVANZPAL4:,VVANZAPAL4=:VVANZAPAL4:,VVANZRPAL4=:VVANZRPAL4:,VVLB5=:VVLB5:,VVANZPAL5=:VVANZPAL5:,VVANZAPAL5=:VVANZAPAL5:,VVANZRPAL5=:VVANZRPAL5:,VVLB6=:VVLB6:,VVANZPAL6=:VVANZPAL6:,VVANZAPAL6=:VVANZAPAL6:,VVANZRPAL6=:VVANZRPAL6:,VVKOLP=:VVKOLP:,VVVPLP=:VVVPLP:,VVTPSTA=:VVTPSTA:,VVTPMA1=:VVTPMA1:,VVTPMAANZ1=:VVTPMAANZ1:,VVTPMA2=:VVTPMA2:,VVTPMAANZ2=:VVTPMAANZ2:,VVGTBS=:VVGTBS:,VVGTBK=:VVGTBK:,VVKM1=:VVKM1:,VVGTBZ=:VVGTBZ:,VVKM2=:VVKM2:,VVTARIF1=:VVTARIF1:,VVORTKL1=:VVORTKL1:,VVFRPFL1=:VVFRPFL1:,VVLAKL1=:VVLAKL1:,VVFRSATZ1=:VVFRSATZ1:,VVFRERRECH1=:VVFRERRECH1:,VVMARGEP1=:VVMARGEP1:,VVMARGEA1=:VVMARGEA1:,VVSUMME1=:VVSUMME1:,VVTARIF2=:VVTARIF2:,VVORTKL2=:VVORTKL2:,VVFRPFL2=:VVFRPFL2:,VVLAKL2=:VVLAKL2:,VVFRSATZ2=:VVFRSATZ2:,VVFRERRECH2=:VVFRERRECH2:,VVMARGEP2=:VVMARGEP2:,VVMARGEA2=:VVMARGEA2:,VVSUMME2=:VVSUMME2:,VVTARIF3=:VVTARIF3:,VVORTKL3=:VVORTKL3:,VVFRPFL3=:VVFRPFL3:,VVLAKL3=:VVLAKL3:,VVFRSATZ3=:VVFRSATZ3:,VVFRERRECH3=:VVFRERRECH3:,VVMARGEP3=:VVMARGEP3:,VVMARGEA3=:VVMARGEA3:,VVSUMME3=:VVSUMME3:,VVPRAEMIEV=:VVPRAEMIEV:,VVPOLICE=:VVPOLICE:,VVGDATBIS=:VVGDATBIS:,VVWERTV=:VVWERTV:,VVWAEHRSLV=:VVWAEHRSLV:,VVNEBENKO=:VVNEBENKO:,VVWAEHRSLN=:VVWAEHRSLN:,VVNACHNA=:VVNACHNA:,VVFESTBETR=:VVFESTBETR:,VVVERZOLLT=:VVVERZOLLT:,VVKZABRFR=:VVKZABRFR:,VVZAHLART=:VVZAHLART:,VVZAHLBED=:VVZAHLBED:,VVKZLSPERR=:VVKZLSPERR:,VVANAME1=:VVANAME1:,VVANAME2=:VVANAME2:,VVASTRASSE=:VVASTRASSE:,VVASTRASSE2=:VVASTRASSE2:,VVALAND=:VVALAND:,VVAPLZ=:VVAPLZ:,VVAORT=:VVAORT:,VVABZ=:VVABZ:,VVABZBEZ=:VVABZBEZ:,VVACOUNTY=:VVACOUNTY:,VVACITY=:VVACITY:,VVKUNDNRV=:VVKUNDNRV:,VVADRSLV=:VVADRSLV:,VVKUNDNRE=:VVKUNDNRE:,VVEMPFKZ=:VVEMPFKZ:,VVADRSLL=:VVADRSLL:,VVADRSLO=:VVADRSLO:,VVKUNDNRVF=:VVKUNDNRVF:,VVADRSLKVF=:VVADRSLKVF:,VVADRSLLVF=:VVADRSLLVF:,VVKUNDNRR=:VVKUNDNRR:,VVADRSLKR=:VVADRSLKR:,VVADRSLLR=:VVADRSLLR:,VVKUNDNRF=:VVKUNDNRF:,VVADRSLKF=:VVADRSLKF:,VVADRSLLF=:VVADRSLLF:,VVANTEILF=:VVANTEILF:,VVPI=:VVPI:,VVET=:VVET:,VVLS=:VVLS:,VVPA=:VVPA:,VVLA=:VVLA:,VVFR=:VVFR:,VVAV=:VVAV:,VVDECKBLATT=:VVDECKBLATT:,VVLIEFSCHPOS=:VVLIEFSCHPOS:,VVLPACKNR=:VVLPACKNR:,VVANZTLIEF=:VVANZTLIEF:,VVANZTLIEFR=:VVANZTLIEFR:,VVANZTLIEFB=:VVANZTLIEFB:,VVLIEFTERM=:VVLIEFTERM:,VVFRACHTBE=:VVFRACHTBE:,VVVB=:VVVB:,VVKZKUNDV=:VVKZKUNDV:,VVZONE=:VVZONE:,VVKGBIS=:VVKGBIS:,VVKDVKL=:VVKDVKL:,VVADRSLLUR=:VVADRSLLUR:,VVVALUTA=:VVVALUTA:,VVVALDAT=:VVVALDAT:,VVEKON=:VVEKON:,VVVERSIBE=:VVVERSIBE:,VVVSTK=:VVVSTK:,VVLSTKPA=:VVLSTKPA:,VVPAUFKRS=:VVPAUFKRS:,VVPAUFLFD=:VVPAUFLFD:,VVPAUFPOS=:VVPAUFPOS:,VVVERPKOST=:VVVERPKOST:,VVKOSTBGR=:VVKOSTBGR:,VVVERPKOSTE=:VVVERPKOSTE:,VVLIEFNR=:VVLIEFNR:,VVRENR=:VVRENR:,VVREPOS=:VVREPOS:,VVREDAT=:VVREDAT:,VVFRNETTO=:VVFRNETTO:,VVFRKSTA=:VVFRKSTA:,VVZOLLPAP=:VVZOLLPAP:,VVPROGRP=:VVPROGRP:,VVUEBKZ=:VVUEBKZ:,VVDROFT=:VVDROFT:,VVKREDLIM=:VVKREDLIM:,VVSWING=:VVSWING:,VVRAITING=:VVRAITING:,VVVERS=:VVVERS:,VVKREDBIS=:VVKREDBIS:,VVKREDVON=:VVKREDVON:,VVLUEBKZ=:VVLUEBKZ:,VVFRDAT=:VVFRDAT:,VVFRZEIT=:VVFRZEIT:,VVFRBENID=:VVFRBENID:,VVKUNDNRRE=:VVKUNDNRRE:,VVLIEFART=:VVLIEFART:,VVKTRANSDAT=:VVKTRANSDAT:,VVKTRANSUHR=:VVKTRANSUHR:,VVKTRANSBEN=:VVKTRANSBEN:,VVKTRANSSTA=:VVKTRANSSTA:,VVSTRANSDATA=:VVSTRANSDATA:,VVSTRANSUHRA=:VVSTRANSUHRA:,VVSTRANSERL=:VVSTRANSERL:,VVSTRANSDATE=:VVSTRANSDATE:,VVSTRANSUHRE=:VVSTRANSUHRE:,VVETRANSDAT=:VVETRANSDAT:,VVETRANSUHR=:VVETRANSUHR:,VVETRANSBEN=:VVETRANSBEN:,VVAKTKZ=:VVAKTKZ:,VVPSTKKZ=:VVPSTKKZ:,VVANZVP=:VVANZVP:,VVWAEHRSL=:VVWAEHRSL:,VVHWAEHRSL=:VVHWAEHRSL:,VVHEUROKURS=:VVHEUROKURS:,VVHEUROKURSVK=:VVHEUROKURSVK:,VVFEUROKURS=:VVFEUROKURS:,VVFEUROKURSVK=:VVFEUROKURSVK:,VVLOHNKD=:VVLOHNKD:,VVARCHKZ=:VVARCHKZ:,VVARCHDAT=:VVARCHDAT:,VVARCHBEL=:VVARCHBEL:,VVSEQUNO=:VVSEQUNO:,VVLFDPN=:VVLFDPN:,VVARTGRP=:VVARTGRP:,VVAETINEU=:VVAETINEU:,VVPTARIF=:VVPTARIF:,VVANSPRECH=:VVANSPRECH:,VVANSPZUS=:VVANSPZUS:,VVTRANSSEQ=:VVTRANSSEQ:,VVEDI=:VVEDI:,VVEDIDAT=:VVEDIDAT:,VVQUITTAIO=:VVQUITTAIO:,VVGESMTR=:VVGESMTR:,VVLOAD=:VVLOAD:,VVLVOR=:VVLVOR:,VVUSERFRA=:VVUSERFRA:,VVZEUGNIS=:VVZEUGNIS:,VVFILLER=:VVFILLER:,VVAENDZL=:VVAENDZL:,VVAENDBEN=:VVAENDBEN:,VVAENDDAT=:VVAENDDAT:,VVNEUBEN=:VVNEUBEN:,VVNEUDAT=:VVNEUDAT:"
                        + " WHERE VVMANDANT=:VVMANDANT: AND VVLIEFSCH=:VVLIEFSCH:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 4:
                    or1.CommandText = "UPDATE VVLIEF SET VVSTATUS=:VVSTATUS:"
                        + " WHERE VVMANDANT=:VVMANDANT: AND VVLIEFSCH=:VVLIEFSCH:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 5:
                    or1.CommandText = "UPDATE VVLIEF SET (VVEINZBRUT,VVEINZNET,VVBRUTTO,VVNETTO,VVNETMTR,VVVSTK)  =(SELECT NVL(SUM(VVTKG),0),NVL(SUM(VVTKG),0),NVL(SUM(VVTKG),0),NVL(SUM(VVTKG),0),NVL(SUM(VVTMTR),0),NVL(SUM(VVTANZSTK),0)  FROM VVTLIEF WHERE VVTMANDANT=VVMANDANT AND VVLIEFSCH=VVTLIEFSCH)"
                        + " WHERE VVMANDANT=:VVMANDANT: AND VVLIEFSCH=:VVLIEFSCH:"
                        ;
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 6:
                    or1.CommandText = "UPDATE VVLIEF SET VVVERSDAT=:VVVERSDAT: "
                        + " WHERE VVLIEFSCH=:VVLIEFSCH:"
                        ;
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                /*+ " AND EXISTS (SELECT 1 FROM VVTLIEF WHERE VVTMANDANT=VVMANDANT AND VVLIEFSCH=VVTLIEFSCH)"*/
            }
            Connect2Proxy(or1);
        }

        public void DeleteVVLIEF(DataRow dwData, int option = 1)
        {

            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "DELETE FROM VVLIEF"
                           + " WHERE VVMANDANT=:VVMANDANT:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 1:
                    or1.CommandText = "DELETE FROM VVLIEF"
                           + " WHERE VVMANDANT=:VVMANDANT: AND VVLIEFSCH=:VVLIEFSCH:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        }


    }
}
